sql_data.java

来自「留学生信息管理系统 我的工程实习的项目」· Java 代码 · 共 114 行

package news;

import java.sql.*;
public class sql_data {
//	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//	String url="jdbc:odbc:lsd";
//	String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lsd";
	//pubs为你的数据库的    
//	String user = "sa";
//	String password = "lsd";
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
	

	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lsd"; 
//	pubs为你的数据库的 
	String user="sa"; 
	String password="lsd"; 
	
	
	public String x(){
		String str=	"url:"+url+",user:"+user+",password:"+password+"    "+conn;
		return str;
	}
	
	public sql_data() {
		try {
			//Class.forName(sDBDriver);
//			Class.forName(sDBDriver).newInstance();
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
		} catch (Exception e) {
			System.err.println("sql_data(): " + e.getMessage());
		}
	}
	public void executeInsert(String sql) {
		try {
//			conn = DriverManager.getConnection(url);
			conn = DriverManager.getConnection(url, user, password);
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			stmt.close();
			conn.close();
		} catch (SQLException ex) {
			System.err.println("sql_data.executeUpdate:" + ex.getMessage());
		}
	}
	public ResultSet executeQuery(String sql) {
		try {
//			conn = DriverManager.getConnection(url);
			conn = DriverManager.getConnection(url, user, password);
			stmt =conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

			rs = stmt.executeQuery(sql);
		} catch (SQLException ex) {
			System.err.println("sql_data.executeQuery:" + ex.getMessage());
		}
		return rs;
	}
	public void executeUpdate(String sql) {
		try {
//			conn = DriverManager.getConnection(url);
			conn = DriverManager.getConnection(url, user, password);
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			stmt.close();
			conn.close();
		} catch (SQLException ex) {
			System.err.println("aq.executeQuery: " + ex.getMessage());
		}
	}
	public void executeDelete(String sql) {
		try {
//			conn = DriverManager.getConnection(url);
			conn = DriverManager.getConnection(url, user, password);
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			stmt.close();
			conn.close();
		} catch (SQLException ex) {
			System.err.println("sql_data.executeDelete:" + ex.getMessage());
		}
	}
	public void closeStmt() {
		try {
			stmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void closeConn() {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	
	public static void main(String [] args)throws Exception{
		sql_data s=new sql_data();
		ResultSet rs=s.executeQuery("select * from news_table");
		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));
		}
	}
}