package com;
import java.sql.*;
/** *//**
* @author Administrator
*/
public class ggg {
private Connection con = null;
private Statement stmt = null;
private String url = "jdbc:mysql://localhost/test";
private String user = "root";
private String pwd = "0429";
/** *//** Creates a new instance of Operation */
public ggg() {
init();
}
/** *//** init */
private void init(){
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection(url,user,pwd);
stmt = con.createStatement();
} catch (Exception e){
// your installation of JDBC Driver Failed
e.printStackTrace();
}
}
/** *//**
* TODO 增加一条记录
* @param sn 学生名字
* @param ss 学生性别
* @param sa 学生年龄
* @param so 学生专业
* @return void
*/
public void add(String sn,String ss,String sa,String so){
String sql2 = "insert into student value('"
+sn+"','"+ss+"','"+sa+"',`"+so+"`);";
try{
stmt.execute(sql2);
}catch(SQLException e){
e.printStackTrace();
}
}
/** *//**
* TODO 查询记录
* @param sn 记录的学生姓名
* @return String 查询的结果
*/
public String search(String sn){
String str = "so ：sa ："+sn+" ss：";
String sql1 = "select * from student where sn='"+sn+"';";
try{
ResultSet rs = stmt.executeQuery(sql1);
if(rs.next()){
str = str+rs.getString("sn")+" 手机号："
+rs.getString("sa");
}else str = "该记录不存在！！！";
}catch(Exception e){
e.printStackTrace();
评论16