public class DBConnection {
public static final String url = "jdbc:mysql://localhost:3306/news";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "root";
public static final String password = "987321";
public Connection conn = null;
public Statement pst = null;
public DBConnection(String sql) {
try {
Class.forName(name);
conn = DriverManager.getConnection(url, user, password);
pst = conn.createStatement();
pst.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
try {
this.conn.close();
this.pst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String s1 = "aaaaa"; String s2 = "bbbbb"; String s3= "cccccccccccccccccccccccccccccc";
DBConnection conn = new DBConnection("insert into newscontent(newsType,newsTitle,newsContent) value("+s1+","+s2+","+s3+")");
conn.close();
}
}