jsp连接数据库代码填写

login.jsp <html> <body> <form action="login_do.jsp" method="post"> 用户名:<input type="text" name="username"><br> 密码:<input type="password" name="password"><br> <input type="submit" value="登录"> </form> </body> </html> login_do.jsp <%@ page language="java" import = "java.util.*" import = "java.sql.*" contentType="text/html;charset=GBK"%> <html> <head> </head> <% String sUserName = request.getParameter("username"); String sPWD = request.getParameter("password"); try{ ____________加载驱动________________; _______________设置连接串________________; Connection conn =____创建连接___________________________; Statement stmt = ________创建statement对像_________________; String sql =________设置sql语句_________________; ResultSet rs =________________ if(____判断rs中是否有记录___________) out.println("用户名或密码错误!"); else response.sendRedirect("admin_index.jsp"); }catch(Exception e) { out.println("数据库操作失败!"); System.out.println(e.getMessage()); } %> </html> admin_index.jsp <html> <body> 登录成功!欢迎进入系统 </body> </html> 希望牛叉人士帮我填写下，我开小号帮你刷分！！！

答案：try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WebExam";
Connection conn = DriverManager.getConnection(url,"sa","123456");
Statement stmt = conn.createStatement();
String sql = "select * from tb_user where userName='"+sUserNam+"' and password='"+sPWD+"' ";
ResultSet rs = stmt.executeQuery(sql);
if (!rs.next()) out.println("用户名或密码错误！");
else response.sendRedirect("index.jsp");
}

其他：Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
request.setCharacterEncoding("GB2312");


<%
String url="jdbc:odbc:stuDataBase";                //odbc是数据源，stuDataBase是数据库的名字
Connection con=DriverManager.getConnection(url);    //创建链接
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs= stmt.executeQuery("SELECT * FROM stuInfo WHERE  作者=" +"'" +str + "'");        //stuInfo是数据库里表的名字  后面这句的意思是以作者为字段查找 
%>

希望对楼主有帮助，这是链接数据库的通句，根据具体情况改改就行~~

上一个：求一段MYSQL中的数据插入到jsp中的表格代码！！！
下一个：jsp关于js注册表单验证问题：事件为submit按钮提交验证的onClick事件，先看一下部分主要代码:

更多图片编程知识: