jsp和SQL Server如何实现登录?

[ender369]

jsp如何实现登录?
如何从数据库中取出记录与表单提交的字段进行比较啊？？
麻烦大家给个代码！！

[longshenls]

建议去看 jsp基础的书吧
书上写的非常详细了
例子都有了 你这个问题

[xuwenliangde]

看JSP2.0技术手册

[eric0cn]

这里有一个跟你要的很像：http://zhidao.baidu.com/question/21435639.html?fr=qrl

不过建议楼主还是先啃一本入门书。

[wensheng_zh2007]

import java.sql.*;

public class DbTest {

Connection con;
Statement sta;
ResultSet rs;

String driver;
String url;
String user;
String pwd;
public DbTest()
{
	driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	url = "jdbc:microsoft:sqlserver://localhost:1433";
	user = "****";
	pwd = "****";
	init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver is ok");
con = DriverManager.getConnection(url,user,pwd);
System.out.println("conection is ok");
executeSql("use pubs");
sta = con.createStatement();
rs = sta.executeQuery("select * from employee");
while(rs.next())
System.out.println(rs.getInt("job_id")); 
}catch(Exception e){
e.printStackTrace();
}
}

public void executeSql(String sql) {
		try {
			PreparedStatement ps = con.prepareStatement(sql);
			//Statement ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			ps.executeUpdate();
			ps.close();
			ps = null;
			con.commit();
		
		} catch (SQLException ex) {
			
			try {
				con.rollback();
			} catch (Exception e) {
			}

		}

	}

}  

这是个纯java实现的,参考一下