为什么我这代码显示不出,数据库结果呢?
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Properties;
public class NewClass13 {
public static void main(String[] args)throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String str="jdbc:odbc:wow_t1";
Properties pro=new Properties();
pro.setProperty("ming","sa");
pro.setProperty("xuke","dsa");
Connection con=DriverManager.getConnection(str,pro);
Statement sta=con.createStatement();
ResultSet res=sta.executeQuery("SELECT name FROM TBC");
while(res.next()){
System.out.println(res.getString("name"));
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Properties;
public class NewClass13 {
public static void main(String[] args)throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String str="jdbc:odbc:wow_t1";
Properties pro=new Properties();
pro.setProperty("ming","sa");
pro.setProperty("xuke","dsa");
Connection con=DriverManager.getConnection(str,pro);
Statement sta=con.createStatement();
ResultSet res=sta.executeQuery("SELECT name FROM TBC");
while(res.next()){
System.out.println(res.getString("name"));
}
}
}
还有你连接说明数据库,感觉你连接都错了!
public void opendb(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stumanager",userName,userPwd);
System.out.println("链接成功,打开");
} catch (Exception e) {
System.out.println("不能打开");
e.printStackTrace();
throw new RuntimeException(e.getMessage());
}
}
这个是连接sqlserver的,打开数据库的,完后还要关闭!自己看吧!
驱动可能弄错了,这个是ODBC的……
package com.test.usermanage.util;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class ConnectionUtil { private static String url = "jdbc:oracle:thin:@127.0.0.1:1521:myoracle";
private static String user = "root";
private static String pwd = "root";
private static String driver = "oracle.jdbc.driver.OracleDriver"; static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
} public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, pwd);
}}