jdbc连接数据库

来源：互联网发布：阿里云服务编辑：程序博客网时间：2024/05/17 00:08

//这是使用JDBC-ODBC桥驱动模式
import java.sql.*;
class JBDCTest
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Ntserver","sa","2306");
System.out.println("数据库连接中....");
Statement stmt =conn.createStatement();
ResultSet results =stmt.executeQuery("select * from titles");
//int num=1;
while (results.next())
{
String titles =results.getString("title");
String prices =results.getString("price");
System.out.println("书名:"+titles+" 价格:"+prices);
}
System.out.println("连接关闭中...");
stmt.close();
conn.close();
}
catch (Exception e)
{
}
}
}

Ntserver为数据源

//这是使用JDBC驱动直接连接的驱动模式,
import java.sql.*;
class JDBCTest2
{
public static void main(String[] args)
{
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
String user = "sa";
String pwd = "2306";
try
{
Class.forName(driver/*"com.microsoft.jdbc.sqlserver.SQLServerDriver"*/);
Connection conn =DriverManager.getConnection(url,user,pwd/*"jdbc:microsoft:sqlserver://127.0.0.1:1433;User=xjl;Password=2306;DatabaseName=Shop"*/);
System.out.println("数据库连接中....");
Statement stmt =conn.createStatement();
ResultSet results =stmt.executeQuery("select * from titles");
//int num=1;
while (results.next())
{
String titles =results.getString("title");
String prices =results.getString("price");
System.out.println("书名:"+titles+" 价格:"+prices);
}
stmt.close();
conn.close();
System.out.println("连接关闭中...");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}