哪个知道Servlet中怎么连JDBC要详细点的
来源:百度知道 编辑:UC知道 时间:2024/05/30 14:53:44
import java.sql.*;
public class JtdsDBConnection {
/**
* @param args
*/
public static void main(String[] args) {
String driverName = "net.sourceforge.jtds.jdbc.Driver";
String dbURL = "jdbc:jtds:sqlserver://172.16.15.28:1433/jforum";
String userName = "sa";
String userPwd = "12345678";
Connection con;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "select * from jforum_posts_text";
try {
Class.forName(driverName);
con = DriverManager.getConnection(dbURL, userName, userPwd);
stmt = con.prepareStatement(sql);
rs = stmt.executeQuery();
while(rs.next())
{
System.out.println(rs.getInt("post_id"));
System.out.println(rs.getString("post_text"));
}
System.out.println("Connection Successful!");
}