Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- String driver = "com.mysql.jdbc.Driver";
- Class.forName(driver).newInstance();
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull","root","P@typd79");
- Statement stmt = con.createStatement();
- String query = "INSERT INTO project_one.personal_info(ssn,name,street,city,state,zip,class,degree,s,imm) VALUES"
- + "(" + social + "," + Name + "," + Address + "," + City + "," + State + "," + Zip
- + "," + Year + "," + Degree + "," + HS + "," + IMM + ")";
- stmt.executeUpdate(query);
- JOptionPane.showMessageDialog(null, "New student added successfully");
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null,"Data not saved: " + e,"Error",JOptionPane.ERROR_MESSAGE);
- }
- }
- .;C:j2sdk1.4.2_16jrelib;
- C:Program Filesmysql-connector-java-3.1.144mysql-connector-java-3.1.14-bin.jar
- java -cp ".;C:j2sdk1.4.2_16jrelib;
- C:Program Filesmysql-connector-java-3.1.144mysql-connector-java-3.1.14-bin.jar"
- my.class.Name
Add Comment
Please, Sign In to add comment