ss TestConSql {
public static void main(String[] args) { String driverName = //加载
"com.microsoft.sqlserver.jdbc.SQLServerDriver"; JDBC驱动 2005 String dbURL
= //
"jdbc:
sqlserver://127.0.0.1:1433;DatabaseName=photoDB"; 连接服务器和数据库sample String userName = "sa"; //默认用户名
String userPwd = "123456"; //密码 Connection dbConn; Statement stms; try{ Class.forName(driverName); dbConn = DriverManager.getConnection(dbURL,
userName, userPwd); System.out.println("Connection Successful!"); stms = dbConn.createStatement(); ResultSet rs = stms.executeQuery("select * from users_table"); while(rs.next()){ System.out.print(rs.getString(1)); System.out.print(rs.getString(2)); System.out.println(""); } rs. String k = "hello world"; System.out.println("aaaaaaaaaa"+k+"bbbbbb"); }catch (Exception e) { e.printStackTrace(); }
} }
其中:各种参数要根据你自己的数据库来做相应的修改 带参数的sql语句的写法:
"
select * from users_table where username='
"
+uName+
"
'
and pwd='
"
+passWord+
""
'
7. 编 写 checklogin.jsp页面 代码如下:
<%@page contentType="text/html;charset=GB2312" %> <%@page import="java.sql.*" %> <% String driverName = //加载
"com.microsoft.sqlserver.jdbc.SQLServerDriver"; JDBC驱动 2005 String dbURL
= //
"jdbc:sqlserver://127.0.0.1:1433;DatabaseName=photoDB";
连接服务器和数据库sample String userName = "sa"; //默认用户名
String userPwd = "123456"; //密码 Connection dbConn; Statement stms;
String uName = request.getParameter("user"); String passWord = request.getParameter("pwd");
try{ Class.forName(driverName); dbConn = DriverManager.getConnection(dbURL,
userName, userPwd);
stms = dbConn.createStatement(); String sql = "select * from users_table where username='"+uName+"' and pwd='"+passWord+"' "; ResultSet rs = stms.executeQuery(sql); if(rs.next()){ response.sendRedirect("frameset.htm"); }else{ out.println(""); response.sendRedirect("login.jsp"); } }catch (Exception e) { response.sendRedirect("login.jsp"); } %>
9.启动服务器进行测 试,测试之前,要将 sqljdbc.jar包放入 tomcat下的lib下