编码gbk的不可映射字符,需要class或interface
package com.chrkey.bean;
import java.sql.*;
import java.io.Serializable;
import javax.sql.DataSource;
public class SqlConn implements Serializable {
private String url = "jdbc:mysql://localhost:3306/einfo";
private String user = "root"; // 数据库用户名
private String password = "12345678";
private Connection conn = null; // 数据库连接对象
private Statement stmt = null; // 数据库连接状态对象
private ResultSet rs = null; // 数据库查询结果集
public SqlConn() { //使用JDBC建立数据库连接
try {
Class.forName("com.mysql.jdbc.Driver"); //括号里边为驱动程序名
} catch (java.lang.ClassNotFoundException e) {
System.err.println("SqlConn():" + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(url, user, password); // 获得数据库连接
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY); // 建立Statement对象
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("SqlConn.executeQuery:" + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
} catch (SQLException ex) {
System.err.println("SqlConn.executeUpdate: " + ex.getMessage());
}
}
public void closeStmt() {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void closeConn() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
代码就是上面的,那位可以给个解决方案吗?错误是:警告如题,错误是1,3,4,5行需要class或interface.