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();
}
}
}
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();
}
}
}