--sql文件
create database student
go
use student
go
create table stuinfo
(
--stuid int primary key identity(1,1) not
null,
stuname nvarchar(10) not null,
stupwd nvarchar(20) not null
)
insert into stuinfo values('admin','123')
select * from stuinfo
select stuname,stupwd from stuinfo where stuname='admin'
create table stuinfo_email
(
--stuid int primary key identity(1,1) not
null,
stuname nvarchar(10) not null,
stupwd nvarchar(20) not null,
stuemail nvarchar(20) not null
)
select * from stuinfo_email
insert into stuinfo_email values('1','123','1@sina.com')
----java 代码
package com.svse.ADO;
public class ADO {
private String stuname;
private String stupwd;
public String getStuname() {
return stuname;
}
public void setStuname(String stuname) {
this.stuname = stuname;
}
public String getStupwd() {
return stupwd;
}
public void setStupwd(String stupwd) {
this.stupwd = stupwd;
}
}
----注册
package com.svse.Applion;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.ser