package demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.SQLException;
public class JdbcDemo3 {
/*
* DriverManager:驱动管理对象
* Connection:数据库连接对象
* Statement:执行sql语句的对象
* ResultSet:sql语句执行结果集对象
* PreparedStatement:执行sql的对象
* */
public static void main(String[] args) {
Statement stmt = null;
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
//conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test_2?characterEncoding=utf-8","root","123456");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test_2","root","123456");
String sql = "update ROLE set ROLE_DESC ='收学生的学费' where ID = 1";
stmt = conn.createStatement();
int count = stmt.executeUpdate(sql);
if(count>0){
System.out.println("更新数据表记录成功!");
}else{
System.out.println("更新数据表记录失败!");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if(stmt!=null){
try{
stmt.close();
}catch (SQLException e){
e.printStackTrace();
}
if(conn!=null){
try{
conn.close();
}catch (SQLException e){
e.printStackTrace();
}
}
}
}
}
}
出现中文乱码。
conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/test_2”,“root”,“123456”);
修改为:
conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/test_2?characterEncoding=utf-8”,“root”,“123456”);
中文乱码解决。