jdbc连接mysql

//DbBase.java

package demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DbBase {
 private static Statement st;
 private static Connection con;
 public void init(){
  String driver="com.mysql.jdbc.Driver";
  String username="root";
  String userpass="mysql";
  String url="jdbc:mysql://localhost/test?user="+username+"&password="+userpass;
  try{
  if(con!=null)return;
  Class.forName(driver);
  con=DriverManager.getConnection(url);
  st=con.createStatement();
  }catch(Exception e){
   System.out.println(e);
  }
  
 }

 public void execute(String sql){
  try {
   st.execute(sql);  
  } catch (Exception e) {
   System.out.println(e);
  } 
 }
 public ResultSet executeQuery(String sql){
  ResultSet rs=null;
  try {
   rs = st.executeQuery("select * from Person");
  } catch (Exception e) {
   System.out.println(e);
  }
  return rs;
    
 }
 public void destroy(){
  try{
  st.close();
  con.close();
  }catch(Exception e){
   System.out.println(e);
  }
 } 
}
//Person.java

package demo;

public class Person {
 private int id;
 private String uname;
 private String upass;
 public Person(){
  
 }
 
 public Person(int id,String uname,String upass){
  this.id=id;
  this.uname=uname;
  this.upass=upass;
 }
 
 public int getId() {
  return id;
 }

 public void setId(int id) {
  this.id = id;
 }

 public String getUname() {
  return uname;
 }

 public void setUname(String uname) {
  this.uname = uname;
 }

 public String getUpass() {
  return upass;
 }

 public void setUpass(String upass) {
  this.upass = upass;
 }
}
//PersonTableImpl.java

package demo;

import java.util.*;
import java.sql.*;

public class PersonTableImpl extends DbBase{
 public void save(Person person){
  String sql="insert into Person values('"+person.getId()+"','"+person.getUname()+"','"+person.getUpass()+"')";
  execute(sql);
 }
 public void remove(Person person){
  String sql="delete from person where id="+person.getId();
  execute(sql);
  
 }
 public void modify(Person person){
  String sql="update person set pname='"+person.getUname()+"',password='"+person.getUpass()+"' where id="+person.getId();
  execute(sql);
 }
 public List getAll(){
  return null;
 }
 public Person getById(int id){
  String str="select id,pname,password from person where id="+id;
  Person person1=new Person();
  ResultSet rs=executeQuery(str);
  try{
  rs.next();
  int vId=rs.getInt("id");
  String vName=rs.getString("pname");
  String vPassword=rs.getString("password");
  person1.setId(vId);
  person1.setUname(vName);
  person1.setUpass(vPassword);
  
  }catch(Exception e)
  {
   System.out.println(e);
  }
  return person1;
 }
}
//Testmain.java

package demo;
import java.sql.*;
public class TestMain {
 public static void main(String[] args) {
  //Person temp=new Person(3,"blackmo","115mo");
  PersonTableImpl pt=new PersonTableImpl();  
  pt.init();
  Person temp=new Person();
  temp=pt.getById(3);
  System.out.println(temp.getId());
  System.out.println(temp.getUname());
  System.out.println(temp.getUpass());
  pt.destroy();
  System.out.println("success");
 }

}