这是平时链接数据库用的各种方法,为了方便自己调用而准备的
package proven;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcDemo2 {
public static final String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=UTF-8";
public static final String username = "root"; //数据库账号
public static final String password = ""; //数据库密码(每个人应该都不同)
public static Connection conn =null;
public static Statement stmt = null;
public static ResultSet rs = null;
//安装驱动
static{
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
if(conn!=null){
System.out.println("数据库连接正常");
}else{
System.out.println("数据库连接失败");
}
} catch (Exception e) {
e.printStackTrace();
}
}
//查询方法
public static void query(){
try {
stmt = conn.createStatement();
String sql = "select * from user;";
rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("ID"+rs.getInt("id")+" 姓名:"+rs.getString("name")+" 密码:"+rs.getString("pwd"));
}
} catch (SQLException e) {
e.printStackTrace();
}
finally{
relaseResourse();
}
}
//释放资源
public static void relaseResourse(){
try {
if(rs!=null){
rs.close();
rs = null;
}
if(stmt!=null){
stmt.close();
stmt = null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (Exception e) {
e.printStackTrace();
}
}
//增加数据操作
public static void add(){
try {
stmt = conn.createStatement();
String sql ="insert into user values(null,'abcd','123')";
int result = stmt.executeUpdate(sql);
if(result>0){
System.out.println("添加数据成功");
}else{
System.out.println("添加数据失败");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
relaseResourse();
}
}
//删除数据操作方法
public static void delete(){
try {
stmt = conn.createStatement();
String sql = "delete from user where name='hah';";
//执行
int result = stmt.executeUpdate(sql);
if(result>0){
System.out.println("删除成功");
}else{
System.out.println("删除数据失败");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
relaseResourse();
}
}
//修改方法
public static void update(){
try {
stmt = conn.createStatement();
String sql = "update user set name = 'xiaoxiao' where id='6'";
int result = stmt.executeUpdate(sql);
if(result>0){
System.out.println("修改成功");
}else{
System.out.println("修改数据失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
relaseResourse();
}
}
public static void main(String[] args) {
JdbcDemo2.add();
}
}