import java.sql.*;public class DB {
private Connection con;
public static void main(String[] args)
{
DB db=new DB();
Connection con=db.getConnection();
String sql="Select * From tUser";
db.ExecuteSQL(con,sql); }
public void ExecuteSQL(Connection con,String str)
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(str);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
public Connection getConnection()
{
String url="jdbc:sqlserver://localhost;databaseName=jdsy_BBS;";
String username="sa";
String password="fan";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// String connectionUrl = "jdbc:sqlserver://localhost;" +
// "databaseName=jdsy_BBS;user=sa;password=fan;";
// con = DriverManager.getConnection(connectionUrl);
con=DriverManager.getConnection(url,username,password);
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// Connection con = DriverManager.getConnection
// ("jdbc:microsoft:sqlserver://server1:1433;User=sa;Password=fan"); }
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException ex)
{
ex.printStackTrace();
}
return con;
}
}以上代码肯定没问题,在3.32下运行正常,但是Eclipse3.5.2运行报错。如下Exception in thread "main" java.lang.UnsatisfiedLinkError: com.sun.midp.main.Configuration.getProperty0(Ljava/lang/String;)Ljava/lang/String;
at com.sun.midp.main.Configuration.getProperty0(Native Method)
at com.sun.midp.main.Configuration.getProperty(Configuration.java:32)
at com.sun.midp.lcdui.Resource.<clinit>(Resource.java:30)
at com.sun.midp.main.Main.initSystemLabels(Main.java:686)
at com.sun.midp.main.Main.main(Main.java:103)我E文不行,是不是Eclipse哪里还要配置下。,话说刚刚下下来那会还可以用的。
配置成功了,应为3.3.2版本的Eclipse中能用上面的代码成功访问数据库。