- 论坛徽章:
- 0
|
各位大哥大姐你们好啊!我现在正在做毕业设计!我用的是sql的环境,原来用的是2000,可是在学校还能连接上数据库,可到了我的机子上就不行了,现在我改装了2005还是不行,可否给修改下我的代码了,连接数据库的!谢谢了!!!!!jdbc驱动也弄了的!
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%
String username = request.getParameter("Username");
String passwd = request.getParameter("Password");
String sql = "select * from Userb where Username= '"+username+"' AND Password = '"+passwd+"'";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=fan";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
if(username.equals("root"))
{
%>
<jsp:forward page="success.jsp">
<jsp:param name="Userb" value="<%=username%>"/>
</jsp:forward>
<%
}
else
{
%>
<jsp:forward page="index.jsp">
<jsp:param name="userb" value="<%=username%>"/>
</jsp:forward>
<%}%> |
|