哪个知道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!");
}