下面的代码在derby中创建了一个sample的数据库,并创建了一个表,做了些测试。
package ForTest;
import java.awt.Image;
import java.awt.image.RenderedImage;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Savepoint;
import java.sql.Statement;
import javax.imageio.ImageIO;
public class ConnectDBTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
String driver = "org.apache.derby.jdbc.ClientDriver";
String url = "jdbc:derby://localhost:1527/sample;create=true";
String sql = "create table students(id int,name varchar(20),photo blob)";
String sq