jdbc增删改查

[align=center][size=small][color=gray][color=blue][/color][/color][/size][/align]

最后bean 新建一个类 a1Bean 里面写三个属性id ，name，passwd给他们分别生产get set方法


package com.jdbc;

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

import com.bean.a1Bean;
import com.mysql.jdbc.PreparedStatement;

public class MySQLconnection {
/**
* 得到数据库连接并返回出去
* @return
*/
public static Connection getconncetion() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

String url = "jdbc:mysql://localhost:3306/test";

System.out.println(url);
try {
conn = DriverManager.getConnection(url, "admin", "");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return conn;

}
/**
* 负责增删改操作
* @param al
* @param sqlString
* @return
*/

public boolean intert(a1Bean al,String sqlString) {

Connection conn = getconncetion();
boolean b = false;
try {
PreparedStatement ps = (PreparedStatement) conn
.prepareStatement(sqlString);
ps.setInt(1, al.getId());
ps.setString(2, al.getName());
ps.setString(3, al.getPasswd());
ps.executeUpdate();
b = true;
} catch (SQLException e) {

e.printStackTrace();
}
return b;

}
/**
* 查询全部数据
* @param sqlselectString
* @return
*/
public boolean select(String sqlselectString) {

Connection conn = getconncetion();
boolean b = false;
try {
// PreparedStatement ps = (PreparedStatement) conn
// .prepareStatement(" select * from a1");
//使用参数传递能使方法更灵活
PreparedStatement ps = (PreparedStatement) conn
.prepareStatement(sqlselectString);

java.sql.ResultSet rs = ps.executeQuery();
while (rs.next()) {
b = true;
System.out.print(rs.getInt("id"));
System.out.print(rs.getString("name"));
System.out.println(rs.getString("passwd"));

}

} catch (SQLException e) {

e.printStackTrace();
}
return b;

}




public static void main(String[] args) {
MySQLconnection mysql = new MySQLconnection();

boolean b = mysql.select(" select * from a1");
if (b) {
System.out.println("执行成功");
} else {
System.out.println("执行失败");
}
}
}