java jtds连接数据库
public void sqlTest throws SQLException
{
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/pubs","sa","sa");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM table1");
while(rs.next())
{
String a = rs.getString(0);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
{
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/pubs","sa","sa");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM table1");
while(rs.next())
{
String a = rs.getString(0);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
浙公网安备 33010602011771号