package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class jdbcdemo2
{
public static void main(String[] args)
{
Connection connection = null;
Statement statement = null;
try {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象
try {
connection = DriverManager.getConnection
//("jdbc:mysql://10.211.55.17:3306/db4", "root", "qwer12345");
//?useUnicode=true&characterEncoding=utf8"加这两个参数解决mysql插入乱码问好问题
("jdbc:mysql://10.211.55.17:3306/db4?useUnicode=true&characterEncoding=utf8", "root", "qwer12345");
//定一个增删改sql
String sql = "insert into account values(null,'王五',3000)";
//String sql = "update account set name ='wangwu' where balance=3000";
//String sql = "delete from account where id = 3";
statement = connection.createStatement();
int count = statement.executeUpdate(sql);
//System.out.println(i);
if(count > 0){
System.out.println("添加成功");
}else {
System.out.println("添加失败");
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
//避免空指针异常
if(statement != null)
{
try
{
statement.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
if(connection != null)
{
try
{
statement.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
}