----------------------------------------------END-----------------------------------------------------
JDBC?MYSQLEclipse的连接以及简单的使用(二)
atic final String DBDRIVER = "org.gjt.mm.mysql.Driver";
private static final String DBURL = "jdbc:mysql://localhost:3306/mysql";
private static final String DBUSER = "root";
JDBC_UPD(String name,String character,String introduce) throws SQLException{
Connection conn = null;
Statement st = null;
String sql ="UPDATE game SET gamename = '" + name + "',gamecharacter='" + character +"',gameintroduce='"+ introduce + "' WHERE gamename ='" + name + "'"; //重写N次
conn = DriverManager.getConnection(DBURL,DBUSER,"");
st = conn.createStatement();
st.executeUpdate(sql);
st.close();
conn.close();
}