Creating a SQLServer Table to Store Java Types : SqlServer « Database SQL JDBC « Java






  1. Java
  2. Database SQL JDBC
  3. SqlServer

Creating a SQLServer Table to Store Java Types

import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; publicclass Main { publicstaticvoid main(String[] argv) throws Exception { String driverName = "com.jnetdirect.jsql.JSQLDriver"; Class.forName(driverName); String serverName = "127.0.0.1"; String portNumber = "1433"; String mydatabase = serverName + ":" + portNumber; String url = "jdbc:JSQLConnect://" + mydatabase; String username = "username"; String password = "password"; Connection connection = DriverManager.getConnection(url, username, password); Statement stmt = connection.createStatement(); // Column Name SQLServer Type Java Type  String sql = "CREATE TABLE sqlserver_all_table(" + "col_boolean BIT, "// boolean  + "col_byte TINYINT, "// byte  + "col_short SMALLINT, "// short  + "col_int INTEGER, "// int  + "col_float REAL, "// float  + "col_double DOUBLE PRECISION, "// double  + "col_bigdecimal DECIMAL(13,0), "// BigDecimal; can also be NUMERIC(p,s)  + "col_string VARCHAR(254), "// String  + "col_date DATETIME, "// Date  + "col_time DATETIME, "// Time  + "col_timestamp TIMESTAMP, "// Timestamp  + "col_characterstream TEXT, "// CharacterStream or AsciiStream (< 2 GBytes)  + "col_binarystream IMAGE)"; // BinaryStream (< 2 GBytes)  stmt.executeUpdate(sql); } }








Related examples in the same category

1.Load driver for SQL Server
2.Connect to a database and read from table
3.Connecting to a SQLServer Database using the NetDirect JDBC driver
close