给你一个范例:
import java.sql.*;
import java.applet.*;
import java.awt.*;
import java.awt.event.*;public class DbSql
{ public static void main(String args[])
{
try
{
String url="jdbc:inetdae7:202.121.64.252:1433?database=test";
String driver="com.inet.tds.TdsDriver";
driver="jdbc:sqlserver://202.121.67.141:1433;databasename=Graduate";
Class.forName(driver).newInstance();
String login = "test";
String password = "test";
Connection con=DriverManager.getConnection(url,login,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM Law"); while (rs.next())
{
System.out.println(String.valueOf(rs.getInt("LawType"))+"tt");
}
System.out.println();
st.close();
con.close();
}
catch(java.sql.SQLException e){System.out.println(e.toString());}
catch(java.lang.ClassNotFoundException e){System.out.println(e.toString());}
catch(java.lang.InstantiationException e){System.out.println(e.toString());}
catch(java.lang.IllegalAccessException e){System.out.println(e.toString());}
}
}给点分吧,等米下锅呢
import java.sql.*;
import java.applet.*;
import java.awt.*;
import java.awt.event.*;public class DbSql
{ public static void main(String args[])
{
try
{
String url="jdbc:inetdae7:202.121.64.252:1433?database=test";
String driver="com.inet.tds.TdsDriver";
driver="jdbc:sqlserver://202.121.67.141:1433;databasename=Graduate";
Class.forName(driver).newInstance();
String login = "test";
String password = "test";
Connection con=DriverManager.getConnection(url,login,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM Law"); while (rs.next())
{
System.out.println(String.valueOf(rs.getInt("LawType"))+"tt");
}
System.out.println();
st.close();
con.close();
}
catch(java.sql.SQLException e){System.out.println(e.toString());}
catch(java.lang.ClassNotFoundException e){System.out.println(e.toString());}
catch(java.lang.InstantiationException e){System.out.println(e.toString());}
catch(java.lang.IllegalAccessException e){System.out.println(e.toString());}
}
}给点分吧,等米下锅呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货