MyEclipse和数据库连接

来源：百度知道 编辑：UC知道 时间：2024/05/31 23:08:57
这个是程序

package com.score.database;

import java.sql.*;

public class Database {

/**
* @param args
*/
public static void main(String[] args) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("1");
Connection conn=null;
Statement st=null;
ResultSet rs=null;
conn=DriverManager.getConnection(
"jdbc:microsoft:sqlserver:" +
"//localhost:1433;" +
"databasename=myself"
,"sa","");
System.out.println("2");
st=conn.createStatement();
rs=st.executeQuery("select * from student");
while(rs.next()){
System.out.println(rs.getString(1));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

“A configuration error occurred during startup.Please verify the preference field with the prompt :Not find free Socket ”

出现这个可能是端口被防火墙之类的软件关了，最好的办法是打开端口，实不行就把防火墙关了。

实在是不行就用Mysql数据库吧Mysql6.0 再加MysqlFront5.0（图形界面）连接数据库的程序 驱动是迅雷下载mysql-connector-java-5.0.8.zip里的jar文件程序是package doris;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private Connection conn;
private final String className="com.mysql.jdbc.Driver";
private final String url="jdbc:mysql://localhost:3306/doris";//数据库名doris
private final String user="root";
private final String password="doris";
public DBConnection(){
try {
Class.forName(className);
conn=DriverManager.getConnection(url,user,password);
}catch(ClassNotFoundException e){
System.out.println("加载驱动出错");
e.printStackTrace();
}catch