jdbctest.java

来自「有关ＪＤＢＣ」· Java 代码 · 共 29 行

import java.sql.*;
public class JDBCTest{
	public static void main(String args[]){
		String url="jdbc:odbc:mm";
		String user="sa";
		String password="";
		String ls_1="select * from ss.ll.Student";
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			System.out.println("注册成功");
			Connection con=DriverManager.getConnection(url,user,password);
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery(ls_1);
			System.out.print("name ");
			if(rs.next()){
				System.out.print(rs.getString(1)+"  |");
			}
			rs.close();
			stmt.close();
			con.close();
		}
		catch(SQLException sqle){
			System.out.print(1+sqle.toString());
		}
		catch(Exception e){
			System.out.println(2+e.toString());
		}
	}
}