testsql.java

来自「一个基于java的局域网聊天程序」· Java 代码 · 共 22 行

import java.sql.*;
import com.microsoft.jdbc.sqlserver.*;
import javax.swing.JOptionPane;
public class TestSql {

	public static void main(String[] args) throws Exception {
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		System.out.println("Driver is OK...");
		String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xiajing"; 
		//mydb为数据库 
		String user="sa"; 
		String password=""; 
		Connection con= DriverManager.getConnection(url,user,password); 
		Statement state=con.createStatement();
		ResultSet rs=state.executeQuery("select * from register");
		while(rs.next())
			System.out.println(rs.getString("帐号"));
		
	}

}