4.9w+
社区成员
public class FirstJDBC {
Connection con = null;
Statement stmt = null;
String surl, suser, spsw;
FirstJDBC(String url, String user, String psw){
surl = url;
suser=user;
spsw=psw;
connectDB();
}
public void clean(){
try {
con.close();
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public Statement connectDB(){
try {
con = DriverManager.getConnection(surl, suser,spsw);
stmt = con.createStatement();
return stmt;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public void Query(String sql){
ResultSet result = null;
try {
result = stmt.executeQuery(sql);
while(result.next()){
int id = result.getInt("id");
String ban = result.getString("name");
System.out.println(id+" "+ban);
}
if(result!=null){
result.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public void Insert(String sql){
try {
stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
FirstJDBC j = new FirstJDBC("jdbc:mysql://109.105.114.137/dingheng", "root", "");
j.Insert("insert into hetest values('linuxx','linuxx')");
j.clean();
}
}