public class SQLLink {
final String uri="jdbc:mysql://localhost:3306/shopping?"+"user=root&password=&characterEncoding=utf-8";
Connection con;
Statement sql;
public void link() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(uri);
sql=con.createStatement();
}
public void executeSQL(String sql1) throws Exception { //执行sql语句
link();
sql.executeUpdate(sql1);
closeLink();
}
public ResultSet rsSQL(String sql1) throws Exception { //执行sql语句并返回resultset
link();
return sql.executeQuery(sql1);//需要关闭
}
public boolean booSQL(String sql1) throws Exception{ //执行sql语句并返回是否,一般用于查询
boolean boo=rsSQL(sql1).next();
rsSQL(sql1).close();
closeLink();
return boo;
}
public int intLink(String sql1) throws Exception { //执行sql语句并返回数据表变化的行数
link();
int intrs=sql.executeUpdate(sql1);
con.close();
return intrs;
}
public String[] arraySQL(String sql1) throws Exception{ //执行sql语句并返回一个数组,用于查询数据表中列的所有数据
ResultSet rs=rsSQL(sql1);
String string="";
String name=sql1.split(" ")[1];
while(rs.next()) {
string=string+","+rs.getString(name);
}
rs.close();
closeLink();
return string.substring(1, string.length()).split(",");
}
public void closeLink() throws Exception { //关闭数据库连接
sql.close();
con.close();
}
}
09-12
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交