以下是和 sql2000 连接的,字段名只是参考,相信对你有帮助。如果是和其他数据库连接
只要修改连接部分的语句,网上都有格式。
这个是登陆的代码:
<%
String no=new String();
no=request.getParameter("no");
String psw=new String();
psw=request.getParameter("psw");
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException e){}
try{con=DriverManager.getConnection("jdbc:odbc:sun","sa","密码");
sql=con.createStatement();
String condition="select * from studentInfo where sid= "+"'"+no+"'"+" and psw=
"+"'"+psw+"'";
rs=sql.executeQuery(condition);
if(rs.next()==false)
{out.println("密码或用户名不正确!您现在是游客身份!");}
else {out.println("登陆成功,欢迎您,"+rs.getString("name"));}
con.close();
}
catch(SQLException e1){}
%>
下面是注册的代码,字段视具体情况定:
<%
request.setCharacterEncoding("GBK");
String uname=new String();
String num=new String();
String psw=new String();
String psw1=new String();
String sex=new String();
String clas=new String();
String email=new String();
psw1=request.getParameter("psw1");
uname=request.getParameter("uname");
num=request.getParameter("num");
psw=request.getParameter("psw");