package database;import java.sql.*;
import java.util.*;
import java.text.*;
import java.io.*;public class jdbc_sql {
String conn_str = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myweb";//---------数据库 String username = "sa";//---------------数据库用户名 String password = "sa";//-------------数据库密码 private Connection conn = null; private Statement stmt = null; ResultSet rs = null; //----------------------数据库链接----------------
public jdbc_sql()
{
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.println("dbclass():" + e.getMessage());
}
try {
conn = DriverManager.getConnection(conn_str, username, password);
} catch (SQLException ex) {
System.err.println("dbclass():" + ex.getMessage());
}
} //---------------------数据库查询-----------------
public ResultSet query(String sql) {
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("query():" + ex.getMessage());
}
return rs;
}
package database;import java.sql.*;/**
*
*
* TODO 要更改此生成的类型注释的模板,请转至 窗口 - 首选项 - Java - 代码样式 - 代码模板
*/
public class Test { public static void main(String[] args) {
try {
jdbc_sql bean = new jdbc_sql();
String sql = "select * from aa";
ResultSet rs = bean.query(sql);
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(1)); }
rs.close();
bean.closeconn();
} catch (Exception e) {
e.printStackTrace();
} }
}
import java.util.*;
import java.text.*;
import java.io.*;public class jdbc_sql {
String conn_str = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myweb";//---------数据库 String username = "sa";//---------------数据库用户名 String password = "sa";//-------------数据库密码 private Connection conn = null; private Statement stmt = null; ResultSet rs = null; //----------------------数据库链接----------------
public jdbc_sql()
{
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.println("dbclass():" + e.getMessage());
}
try {
conn = DriverManager.getConnection(conn_str, username, password);
} catch (SQLException ex) {
System.err.println("dbclass():" + ex.getMessage());
}
} //---------------------数据库查询-----------------
public ResultSet query(String sql) {
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("query():" + ex.getMessage());
}
return rs;
}
package database;import java.sql.*;/**
*
*
* TODO 要更改此生成的类型注释的模板,请转至 窗口 - 首选项 - Java - 代码样式 - 代码模板
*/
public class Test { public static void main(String[] args) {
try {
jdbc_sql bean = new jdbc_sql();
String sql = "select * from aa";
ResultSet rs = bean.query(sql);
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(1)); }
rs.close();
bean.closeconn();
} catch (Exception e) {
e.printStackTrace();
} }
}
如果不是win2003,你查看一下你的1433端口是否被屏蔽
如果改端口,既要改sqlserver的端口,也要改jdbc程序的端口