UC知道急！jsp 程序出错！请人帮忙啊！
来源：百度知道 编辑：UC知道 时间：2024/06/20 14:07:43
源程序：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" pageEncoding="GBK" import="java.sql.*"%>
<% Class.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lj";
String user="sa";
String password="19850708";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String city=request.getParameter("city");
String ci=request.getParameter("ci");
String ljc=request.getParameter("ljc");
int o=Integer.parseInt(ljc);
String sql="insert into biao values("+city+","+ci+","+ljc+")";
String sq="select * from
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" pageEncoding="GBK" import="java.sql.*"%>
<% Class.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lj";
String user="sa";
String password="19850708";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String city=request.getParameter("city");
String ci=request.getParameter("ci");
String ljc=request.getParameter("ljc");
int o=Integer.parseInt(ljc);
String sql="insert into biao values("+city+","+ci+","+ljc+")";
String sq="select * from
{ String sqq = "IF NOT EXISTS ('"+sq+"') BEGIN '"+sele+"' END";
ResultSet rss = stmt.executeQuery(sqq);
你的大括号匹配都乱了,这里多了个大括号,下面的大括号都还有问题 也许你想把这个括号写在if(rs.next()) 后面,if(rs.next()) {
!!!!!
if(rs.next()) {
out.print(rs);
String sqq = "IF NOT EXISTS ('"+sq+"') BEGIN '"+sele+"' END";
ResultSet rss = stmt.executeQuery(sqq);
if(rss.next())
{
int rs1=stmt.executeUpdate(sql);
out.print("相近值是" + rss);
}
else
out.print("已经存在。");
}
else
{
out.print("数据库联不上");
}
else{
out.print("已经存在。");
}
这样行不行？试试。。。