Question

jsp连接数据库代码怎么写?

用SQL secver 2005

Answer 1

给你一个javabean吧
package openjdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class openjdbc {

private String url = "jdbc:sqlserver://localhost:1433;DatabaseName=学生信息管理"; //数据库名
private String userName = "sa"; //数据库用户名
private String password = "Lui1988*"; //数据库密码

private ResultSet rs;
private Connection conn = null; //连接对象
private Statement stmt = null;

public openjdbc()
{
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
System.err.println("openjdbc():"+e.getMessage());
}
}

public ResultSet executeQuery(String sql)
{
try
{
conn = DriverManager.getConnection(url, userName, password);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);

}
catch(SQLException e)
{
System.err.println("rs.exectueQuery:"+e.getMessage());
}
return rs;
}
}

相应的数据自己改下,这个得要数据库的jdbc驱动!

Answer 2

网站上看.自己学