- Joined
- Jul 13, 2016
- Posts
- 30,489
- Solutions
- 10,610
- Reaction
- 20,265
- Points
- 17,719
- Age
- 24
Konting help naman po sa code ko , gusto ko po sanang gumawa ng features na nag ce create ng table galing kay user, tapos yubng user po pwede ding mag add ng column, tsaka ko po ilalagay yung table sa mysql pag ka pindot ng submit button
eto po yung error
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at Student_Management_System.your_addtabbleIF.createTable(your_addtabbleIF.java:61)
eto po yung code
eto po yung error
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at Student_Management_System.your_addtabbleIF.createTable(your_addtabbleIF.java:61)
eto po yung code
Java:
public void createTable(String accid,String ColumnNameUser) {
DefaultTableModel model = (DefaultTableModel) AT_table.getModel();
String[] Columnname = null;
for(int i = 0; i < model.getColumnCount() ; i++){
Columnname[i] = model.getColumnName(i);
}
Connection con;
String query = "CREATE TABLE ?_?(";
int noColumn = model.getColumnCount();
for(int i = 0 ; i < noColumn; i++){
query += Columnname[i]+" VARCHAR(100)"+(i!= noColumn - 1?",":"");
}
JOptionPane.showMessageDialog(null, query);
try {
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection("jdbc:mysql://localhost/my_database", "root", "");
PreparedStatement ps = con.prepareStatement(query+")");
ps.setString(1, accid);
ps.setString(2, ColumnNameUser);
ps.executeUpdate();
}
catch (SQLException e ) {
System.out.println("An error has occured on Table Creation "+ e.getMessage());
}
catch (ClassNotFoundException e) {
System.out.println("An Mysql drivers were not found");
}
}
Last edited: