UC知道JSP页面中连接SQLServer的错误
来源：百度知道 编辑：UC知道 时间：2024/06/20 05:37:55
BODY体如下：
<body>
<%
String username=request.getParameter("uid");
String password=request.getParameter("upwd");
if(username!=null&!username.equals("")){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test","sa","");
Statement stmt=conn.createStatement();
String sql="select * from users where username='"+username+"'";
sql+="and password='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("login","ok");
session.setAttribute("uname",username);
%>
<jsp:forward page="main.jsp"></jsp:forward>
<body>
<%
String username=request.getParameter("uid");
String password=request.getParameter("upwd");
if(username!=null&!username.equals("")){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test","sa","");
Statement stmt=conn.createStatement();
String sql="select * from users where username='"+username+"'";
sql+="and password='"+password+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("login","ok");
session.setAttribute("uname",username);
%>
<jsp:forward page="main.jsp"></jsp:forward>
if(username!=null&!username.equals(""))这行怎么就一个& 、？
用这些数据库参数能登陆数据库吗？自己要先试一下，还有sql语句
都要在数据库里测试通过才能往程序里编写的！给你看一个获取数据库连接的例子：
private static Connection connect() {
// 创建连接
// 数据库服务参数
String host = "192.168.10.161";
String port = "1521";
String sid = "cjldata";
// 用户参数
String username = "appgen";
String password = "appgen";
Connection con = null;
// URL
String url = "jdbc:oracle:thin:@" + host + ":" + port + ":" + sid;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
还有操作完数据库一定要记得关连接的 写在 finall（）{}里边
自己仔细的再看一下吧