jdbc连接数据库的基本操作

package com.cn.test.domain;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


public class DBConnection {

static class Student{


private int Id;
        private String Name;
        private String Age;
        public Student() {


}
        public  Student(String Name, String Age) {
            this.Name = Name;
            this.Age = Age;
        }


public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public String getAge() {
return Age;
}
public void setAge(String age) {
Age = age;
}

}

连接MySql数据库，用户名和密码都是root   
   private static final String url="jdbc:mysql://localhost:3306/test";
   private static final String username = "root" ;   
   private static final String password = "root" ;  
   static Connection conn=null;  


public static Connection getConnection(){
       
            try {
            //加载MySql的驱动类 
            Class.forName("com.mysql.jdbc.Driver") ;
conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
     
        return conn;
    }
public static void close(Connection conn){
if(conn!=null){
 try {
conn.close() ;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}   
}

}
//insert.
private static  int insertStu(Student student){
Connection conn=getConnection();
int row=0;
String sql="insert into students values(null,?,?)";
PreparedStatement ps=null;
try {
ps=conn.prepareStatement(sql);
ps.setString(1, student.getName());
ps.setString(2, student.getAge());
row=ps.executeUpdate();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return row;
}
//update.

private static int updateStu(){
Connection conn=getConnection();
int row=0;
//String sql="update students set Age=? where id=?";
String sql="update students set Age=? Name=? where id=?";
PreparedStatement ps=null;
Student stu=null;
try {
stu=new Student();
ps=conn.prepareStatement(sql);
ps.setString(1, stu.getAge());
ps.setString(2, stu.getName());
ps.setInt(3, stu.getId());
row=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return row; //返回影响的行数，1为执行成功  
}
//select.
/*public String select  
    {  
        String sql = "select * from (表名) where (列名)=(值)";  
        Connection conn = getConnection();//此处为通过自己写的方法getConnection()获得连接  
        try  
        {  
            Statement stmt = conn.createStatement();  
            ResultSet rs = stmt.executeQuery(sql);  
  
            if(rs.next())  
            {  
                int m1 = rs.getInt(1);//或者为rs.getString(1)，根据数据库中列的值类型确定，参数为第一列  
                String m2 = rs.getString(2);  
            }  
            //可以将查找到的值写入类，然后返回相应的对象  
        }  
        catch (SQLException e)  
        {  
            e.printStackTrace();  
        }  
        return (相应的值的变量);  
    }  

*/
private static List<Student>list(){
Connection conn=getConnection();
String sql="select *from students";
PreparedStatement ps=null;
List<Student> student=new ArrayList<Student>();
try {
ps=conn.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
Student  stu=null;
while(rs.next()){
stu=new Student();
stu.setId(rs.getInt("id"));
stu.setName(rs.getString("name"));
stu.setAge(rs.getString("age"));
student.add(stu);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return student;

}

private  static void deleteStu(int id){
Connection conn=getConnection();
String sql="delete from students where id=?";
PreparedStatement ps=null;
try {
ps=conn.prepareStatement(sql);
ps.setInt(1, id);
ps.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}