import java.sql.*;importjava.util.Scanner;public classJDBCTest {public static voidmain(String[] args){
Scanner sc= newScanner(System.in);
System.out.println("请输入要查询的姓名:");
String search_name=sc.next();/****************************连接配置,都是字符串类型*********************************/
//驱动程序名
String driver = "com.mysql.jdbc.Driver";//URL指向要访问的数据库名scutcs
String url = "jdbc:mysql://127.0.0.1:3306/scutcs";//MySQL配置时的用户名
String user = "root";//MySQL配置时的密码
String password = "root";/****************************开启连接数据库*********************************/
try{//加载驱动程序
Class.forName(driver);//连续数据库
Connection conn =DriverManager.getConnection(url, user, password);if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");//statement用来执行SQL语句
Statement statement =conn.createStatement();//要执行的SQL语句
String sql = "select * from student where sname='"+search_name+"'";//结果集
ResultSet rs =statement.executeQuery(sql);
System.out.println("----------------------------------");
System.out.println("执行结果如下所示:");
System.out.println("----------------------------------");
System.out.println(" 学号" + "\t" + " 姓名"+ "\t" +"性别");
System.out.println("----------------------------------");
String name= null;
String sex= null;while(rs.next()) {//选择sname这列数据
name = rs.getString("sname");//选择sex这列数据
sex = rs.getString("sex");//首先使用ISO-8859-1字符集将name解码为字节序列并将结果存储新的字节数组中。//然后使用GB2312字符集解码指定的字节数组//name = new String(name.getBytes("ISO-8859-1"),"GB2312");
name = newString(name);
sex= newString(sex);//输出结果
System.out.println(rs.getString("sno") + "\t" + name+ "\t" +sex);
}
rs.close();
conn.close();
}catch(ClassNotFoundException e) {
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}catch(Exception e) {
e.printStackTrace();
}
}
}